Problem Note 57564: The Load_STG2DM_Geo_prod_cost_fact job generates "ERROR: Invalid DO loop control information..."
The SAS® Revenue Optimization Load_STG2DM_Geo_prod_cost_fact job might generate the following errors in the <DDMONYYYY_HH_MM_SS>Load_STG2DM_Geo_prod_cost_fact..etl_exec_job.<n>.log file:
NOTE: Argument 1 to function ATTRN at line 422 column 85 is invalid.
ERROR: Invalid DO loop control information, either the INITIAL or TO expression
is missing or the BY expression is missing, zero, or invalid.
dsid=0 num=. i=1 name= len_excp_msg1=. rc=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of
the operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 422:85
NOTE: The SAS System stopped processing this step because of errors.
....
len_excp_msg1=
ERROR: Variable ETLS_EXCEPTION_COND not found in di_mon.STG_GEO_PROD_COST_X table
...
ERROR: Execution terminated by an %ABORT statement.
SYMBOLGEN: Macro variable JOB_ID resolves to <n>
SYMBOLGEN: Macro variable SYSCC resolves to 20000
SYMBOLGEN: Macro variable JOB_ID resolves to <n>
SYMBOLGEN: Macro variable MP_UNITS_PROCESSED resolves to <n>
SYMBOLGEN: Macro variable SYSCC resolves to 20000
UNIT INFO: Completed Processing SYSCC = 20000
The errors are generated because the job is unable to open the DI_MON.STG_GEO_PROD_COST_X table. If other unit jobs are able to successfully open the DI_MON.STG_GEO_PROD_COST_X table, then the problem is caused by multiple jobs running concurrently.
To work around this issue, set the NUM_PARALLEL_EXECUTIONS global setting to 1 to prevent multiple Load_STG2DM_Geo_prod_cost unit jobs from running concurrently.
Operating System and Release Information
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Retail Forecasting | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Windows 7 Ultimate x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-02-04 13:45:26 |
| Date Created: | 2016-02-02 12:41:34 |
